package com.example.springboot.mapper;

import com.example.springboot.entity.Room;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface RoomMapper {
    @Select("SELECT * FROM room")
    List<Room> findAll();
//    查房间号等信息
    @Select("SELECT * FROM room WHERE room_id = (SELECT room_id FROM course_sort WHERE course_id =#{course_id})")
    List<Room> room_msg(Integer course_id);


}
